About

Amiya Ranjan Ray is a Senior Data & Reporting Engineer with over 15 years of experience in Information Technology, specializing in Business Intelligence, Data Warehousing, and Data Analytics. He has extensive experience in BI Reporting & Visualization using IBM Cognos Analytics, Microsoft Power BI, and Tableau. He is also proficient in OLAP & Metadata Modelling using IBM Cognos Framework Manager, Transformer, and TM1. Amiya has worked with various RDBMS systems such as SQL Server, Oracle, Azure SQL, and Cosmos. In addition to his technical skills, Amiya is well-versed in Cloud Technologies such as Azure Databricks, Azure SQL, and COSMOS. He has experience in Data Integration using SSIS and scripting languages such as Python, Unix Shell Script, and Batch Scripts. Amiya is also proficient in scheduling tools such as Autosys and Crontab. Amiya is an IBM Certified Cognos Report Author and IBM Certified Cognos TM1 Developer. He has also been certified by America Insurance in Property and Liability Insurance. Amiya has volunteered and contributed significantly to organizational training, recruitment, coaching & mentoring young talents, designing POC, and creating new project proposals. Currently, Amiya is serving as a Senior Data & Reporting Engineer at Guy Carpenter, where he has successfully led multiple Reporting, Dashboarding, and Analytics projects for various stakeholders. He has played various roles such as tech mentor, tech lead, developer, and team player. Amiya has been challenged and enjoyed learning and working in multiple technologies like Cognos Analytics, Power BI, Databricks, Oracle, Data Lakes, SQL, Cubes, DMR, and other tools in the BI & Analytics space. He has helped save upwards of half a million in terms of dashboard optimization and performance tuning. Amiya has previously worked as a BI Cognos Developer/Analyst at The Children's Place and as a Senior Cognos Developer at Costco Wholesale. He holds a BCA degree from Bangalore University, an MBA degree from IBMR, and has completed his high school education from Gediaplli High School, Odisha, and Prana Nath Autonomous College, Khurda, Odisha. Amiya's technical skills include SQL, Databricks, Azure, Python, Integration, Data Warehouse, Mobile, and QA. With 16.78 years of relevant experience, Amiya is a seasoned professional who demonstrates solid analytical and long-term goal-oriented thinking, leads